Create PROCEDURE [dbo].[EShop_GhestInsert]
    @AutoIdGhest NUMERIC(18, 0)  ,
    @PriceGhest  MONEY ,
   @IdGhest     NUMERIC(18,0),
   @DateDr      SMALLDATETIME
AS
    DECLARE @id bigint = scope_identity()
	Begin Try
	Begin Tran
      UPDATE ghest SET Daryaft=@PriceGhest,Status_Edit=9 ,Date_Dr=@DateDr WHERE AutoId=@AutoIdGhest AND Id_Ghest=@IdGhest 
	Commit Tran
    RETURN @id
	
	End Try
	Begin Catch
	  RollBack Tran
	  set @Id = -1
	  return @id
	End CATCH
    